﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Collections;

namespace Fingu.XJ.Excel
{
    public interface IExcel
    {
        void SetSheetPage(int arg);
        Microsoft.Office.Interop.Excel._Worksheet GetSheetPage();

        void SetStartCell(string arg);
        string GetStartCell();
        
        void SetStartColumn(string arg);
        string GetStartColumn();
        
        void SetStopCell(string arg);
        string GetStopCell();
        
        void SetStopColumn(string arg);
        string GetStopColumn();


        bool Create();
        bool Open(string filePath, bool appVisible, string pw);
        bool Close();

        bool WriteIn(string ProductID, string[] Datas, string Employer, string TestDateTime, string InspectionState);
        bool WriteIn(string[] ProductID, ArrayList Datas, string[] Employer, string[] TestDateTime, string[] InspectionState);
        bool ReadOut(ref string[,] Datas);

        bool Save(string filePath);
        bool SavaAs(string filePath);
    }
}
